package com.red.star.wechat.data.mappers;

import com.red.star.wechat.data.core.base.MyMapper;
import com.red.star.wechat.data.entity.HostingVoice;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @ProjectName: macalline-data-server
 * @Package: com.red.star.macalline.data.mappers
 * @Description:
 * @Author: AMGuo
 * @CreateDate: 2018/8/31 下午2:02
 * @Version: 1.0
 */
public interface HostingVoiceMapper extends MyMapper<HostingVoice> {

    @Select("select * from t_hosting_voice t where t.subscription_id  = #{subscriptionId} and t.`status` = 1")
    HostingVoice findBySubscriptionId(@Param("subscriptionId") String subscriptionId);
}
